<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<link rel="STYLESHEET" href="lib.css" type='text/css' />
<link rel="SHORTCUT ICON" href="../icons/pyfav.png" type="image/png" />
<link rel='start' href='../index.html' title='Python documentation Index' />
<link rel="first" href="lib.html" title='Python library Reference' />
<link rel='contents' href='contents.html' title="Contents" />
<link rel='index' href='genindex.html' title='Index' />
<link rel='last' href='about.html' title='About this document...' />
<link rel='help' href='about.html' title='About this document...' />
<link rel="next" href="node346.html" />
<link rel="prev" href="sqlite3-Types.html" />
<link rel="parent" href="sqlite3-Types.html" />
<link rel="next" href="node346.html" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name='aesop' content='information' />
<title>13.13.4.1 Introduction</title>
</head>
<body>
<div class="navigation">
<div id='top-navigation-panel' xml:id='top-navigation-panel'>
<table align="center" width="100%" cellpadding="0" cellspacing="2">
<tr>
<td class='online-navigation'><a rel="prev" title="13.13.4 sqlite and Python"
  href="sqlite3-Types.html"><img src='../icons/previous.png'
  border='0' height='32'  alt='Previous Page' width='32' /></a></td>
<td class='online-navigation'><a rel="parent" title="13.13.4 sqlite and Python"
  href="sqlite3-Types.html"><img src='../icons/up.png'
  border='0' height='32'  alt='Up one Level' width='32' /></a></td>
<td class='online-navigation'><a rel="next" title="13.13.4.2 using adapters to"
  href="node346.html"><img src='../icons/next.png'
  border='0' height='32'  alt='Next Page' width='32' /></a></td>
<td align="center" width="100%">Python Library Reference</td>
<td class='online-navigation'><a rel="contents" title="Table of Contents"
  href="contents.html"><img src='../icons/contents.png'
  border='0' height='32'  alt='Contents' width='32' /></a></td>
<td class='online-navigation'><a href="modindex.html" title="Module Index"><img src='../icons/modules.png'
  border='0' height='32'  alt='Module Index' width='32' /></a></td>
<td class='online-navigation'><a rel="index" title="Index"
  href="genindex.html"><img src='../icons/index.png'
  border='0' height='32'  alt='Index' width='32' /></a></td>
</tr></table>
<div class='online-navigation'>
<b class="navlabel">Previous:</b>
<a class="sectref" rel="prev" href="sqlite3-Types.html">13.13.4 SQLite and Python</a>
<b class="navlabel">Up:</b>
<a class="sectref" rel="parent" href="sqlite3-Types.html">13.13.4 SQLite and Python</a>
<b class="navlabel">Next:</b>
<a class="sectref" rel="next" href="node346.html">13.13.4.2 Using adapters to</a>
</div>
<hr /></div>
</div>
<!--End of Navigation Panel-->

<h3><a name="SECTION00151341000000000000000">
13.13.4.1 Introduction</a>
</h3>

<p>
SQLite natively supports the following types: NULL, INTEGER, REAL, TEXT, BLOB.

<p>
The following Python types can thus be sent to SQLite without any problem:

<p>
<div class="center"><table class="realtable">
  <thead>
    <tr>
      <th class="center">Python type</th>
      <th class="left"  >SQLite type</th>
      </tr>
    </thead>
  <tbody>
    <tr><td class="center" valign="baseline"><code>None</code></td>
        <td class="left"  >NULL</td></tr>
    <tr><td class="center" valign="baseline"><code>int</code></td>
        <td class="left"  >INTEGER</td></tr>
    <tr><td class="center" valign="baseline"><code>long</code></td>
        <td class="left"  >INTEGER</td></tr>
    <tr><td class="center" valign="baseline"><code>float</code></td>
        <td class="left"  >REAL</td></tr>
    <tr><td class="center" valign="baseline"><code>str (UTF8-encoded)</code></td>
        <td class="left"  >TEXT</td></tr>
    <tr><td class="center" valign="baseline"><code>unicode</code></td>
        <td class="left"  >TEXT</td></tr>
    <tr><td class="center" valign="baseline"><code>buffer</code></td>
        <td class="left"  >BLOB</td></tr></tbody>
</table></div>

<p>
This is how SQLite types are converted to Python types by default:

<p>
<div class="center"><table class="realtable">
  <thead>
    <tr>
      <th class="center">SQLite type</th>
      <th class="left"  >Python type</th>
      </tr>
    </thead>
  <tbody>
    <tr><td class="center" valign="baseline"><code>NULL</code></td>
        <td class="left"  >None</td></tr>
    <tr><td class="center" valign="baseline"><code>INTEGER</code></td>
        <td class="left"  >int or long, depending on size</td></tr>
    <tr><td class="center" valign="baseline"><code>REAL</code></td>
        <td class="left"  >float</td></tr>
    <tr><td class="center" valign="baseline"><code>TEXT</code></td>
        <td class="left"  >depends on text_factory, unicode by default</td></tr>
    <tr><td class="center" valign="baseline"><code>BLOB</code></td>
        <td class="left"  >buffer</td></tr></tbody>
</table></div>

<p>
The type system of the <tt class="module">sqlite3</tt> module is extensible in two ways: you can store
additional Python types in a SQLite database via object adaptation, and you can
let the <tt class="module">sqlite3</tt> module convert SQLite types to different Python types via
converters.

<p>

<div class="navigation">
<div class='online-navigation'>
<p></p><hr />
<table align="center" width="100%" cellpadding="0" cellspacing="2">
<tr>
<td class='online-navigation'><a rel="prev" title="13.13.4 sqlite and Python"
  href="sqlite3-Types.html"><img src='../icons/previous.png'
  border='0' height='32'  alt='Previous Page' width='32' /></a></td>
<td class='online-navigation'><a rel="parent" title="13.13.4 sqlite and Python"
  href="sqlite3-Types.html"><img src='../icons/up.png'
  border='0' height='32'  alt='Up one Level' width='32' /></a></td>
<td class='online-navigation'><a rel="next" title="13.13.4.2 using adapters to"
  href="node346.html"><img src='../icons/next.png'
  border='0' height='32'  alt='Next Page' width='32' /></a></td>
<td align="center" width="100%">Python Library Reference</td>
<td class='online-navigation'><a rel="contents" title="Table of Contents"
  href="contents.html"><img src='../icons/contents.png'
  border='0' height='32'  alt='Contents' width='32' /></a></td>
<td class='online-navigation'><a href="modindex.html" title="Module Index"><img src='../icons/modules.png'
  border='0' height='32'  alt='Module Index' width='32' /></a></td>
<td class='online-navigation'><a rel="index" title="Index"
  href="genindex.html"><img src='../icons/index.png'
  border='0' height='32'  alt='Index' width='32' /></a></td>
</tr></table>
<div class='online-navigation'>
<b class="navlabel">Previous:</b>
<a class="sectref" rel="prev" href="sqlite3-Types.html">13.13.4 SQLite and Python</a>
<b class="navlabel">Up:</b>
<a class="sectref" rel="parent" href="sqlite3-Types.html">13.13.4 SQLite and Python</a>
<b class="navlabel">Next:</b>
<a class="sectref" rel="next" href="node346.html">13.13.4.2 Using adapters to</a>
</div>
</div>
<hr />
<span class="release-info">Release 2.5.1, documentation updated on 18th April, 2007.</span>
</div>
<!--End of Navigation Panel-->
<address>
See <i><a href="about.html">About this document...</a></i> for information on suggesting changes.
</address>
</body>
</html>
